Remove a hyperlink

To remove a hyperlink and the text that represents it, right-click the cell that contains the hyperlink, and click Clear Contents on the shortcut menu.
To remove a hyperlink and the graphic that represents it, hold down CTRL and click the graphic, and then press DELETE.

Right-click the hyperlink you want to deactivate, and then click Remove Hyperlink on the shortcut menu.

Type the number 1 in a blank cell, and right-click the cell.
Click Copy on the shortcut menu.
While pressing CTRL, select each hyperlink you want to deactivate.
How?
- To select a cell that has a hyperlink in it without jumping to the hyperlink destination, click the cell and hold the mouse button until the cursor becomes a cross , then release the mouse button.
Click Paste Special on the Edit menu.
Under Operation, click Multiply and then click OK.